
package com.lvmama.pangolin.mybatis.mapper.lmm;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.lvmama.pangolin.entity.CommodityConditionVO;
import com.lvmama.pangolin.entity.lmm.LMMTicketCommodity;

public interface LMMTicketCommodityMapper
{

	int deleteByPrimaryKey(String id,String commodityId);
	
	int deleteByProdId(String productId);

	int insert(LMMTicketCommodity record);

	int insertSelective(LMMTicketCommodity record);

	LMMTicketCommodity selectByPrimaryKey(String id,String commodityId);

	List<LMMTicketCommodity> selectByProdId(CommodityConditionVO co);
	
	LMMTicketCommodity selectByProdCommId(@Param("productId")String productId,@Param("commodityId")String commodityId);
	
	int updateByPrimaryKeySelective(LMMTicketCommodity record);

	int updateByProdIdSelective(LMMTicketCommodity record);

	int updateByPrimaryKey(LMMTicketCommodity record);
	
	public void setAsLowest(@Param("product_id")String product_id,@Param("commodity_id")String commodity_id);
	
	public void deleteLowest(@Param("productId")String productId);
	
	public String selectCommodityId(@Param("productId")String productId);
	public List<LMMTicketCommodity> getActiveCommodity(@Param("productId")String productId);
}